Kweku Reginald Wade
04/28/2022
Source: https://www.epa.gov/lmop/lmop-landfill-and-project-database
anaerobicdigesterfas_raw = read_excel("Data/agstar-livestock-ad-database.xlsx", sheet="Operational and Construction")AgSTAR publishes updated data on this website periodically (generally, two times per year) to enhance public access to information and support the development of biogas recovery projects
Source: https://www.epa.gov/agstar/livestock-anaerobic-digester-database
## [1] "GHGRP ID"
## [2] "Landfill ID"
## [3] "Landfill Name"
## [4] "State"
## [5] "Physical Address"
## [6] "City"
## [7] "County"
## [8] "Zip Code"
## [9] "Latitude"
## [10] "Longitude"
## [11] "Ownership Type"
## [12] "Landfill Owner Organization(s)"
## [13] "Year Landfill Opened"
## [14] "Landfill Closure Year"
## [15] "Current Landfill Status"
## [16] "Waste in Place (tons)"
## [17] "Waste in Place Year"
## [18] "LFG Collection System In Place?"
## [19] "LFG Collected (mmscfd)"
## [20] "LFG Flared (mmscfd)"
## [21] "Project ID"
## [22] "Current Project Status"
## [23] "Project Name"
## [24] "Project Start Date"
## [25] "Project Shutdown Date"
## [26] "Project Type Category"
## [27] "LFG Energy Project Type"
## [28] "RNG Delivery Method"
## [29] "Actual MW Generation"
## [30] "Rated MW Capacity"
## [31] "LFG Flow to Project (mmscfd)"
## [32] "Current Year Emission Reductions (MMTCO2e/yr) - Direct"
## [33] "Current Year Emission Reductions (MMTCO2e/yr) - Avoided"
## [1] "Project Name"
## [2] "Project Type"
## [3] "City"
## [4] "County"
## [5] "State"
## [6] "Digester Type"
## [7] "Status"
## [8] "Year Operational"
## [9] "Animal/Farm Type(s)"
## [10] "Cattle"
## [11] "Dairy"
## [12] "Poultry"
## [13] "Swine"
## [14] "Co-Digestion"
## [15] "Biogas Generation Estimate (cu_ft/day)"
## [16] "Electricity Generated (kWh/yr)"
## [17] "Biogas End Use(s)"
## [18] "System Designer(s)_Developer(s) and Affiliates"
## [19] "Receiving Utility"
## [20] "Total Emission Reductions (MTCO2e/yr)"
## [21] "Awarded USDA Funding?"
## [1] "Facility Name" "Category"
## [3] "Type" "City"
## [5] "State" "Start date"
## [7] "Gas Flow to project (scfm)" "Source"
## [9] "Date updated" "Latitude"
## [11] "Longitude" "x"
## [13] "y"
## [1] "ghgrp_id"
## [2] "landfill_id"
## [3] "landfill_name"
## [4] "state"
## [5] "physical_address"
## [6] "city"
## [7] "county"
## [8] "zip_code"
## [9] "latitude"
## [10] "longitude"
## [11] "ownership_type"
## [12] "landfill_owner_organization_s"
## [13] "year_landfill_opened"
## [14] "landfill_closure_year"
## [15] "current_landfill_status"
## [16] "waste_in_place_tons"
## [17] "waste_in_place_year"
## [18] "lfg_collection_system_in_place"
## [19] "lfg_collected_mmscfd"
## [20] "lfg_flared_mmscfd"
## [21] "project_id"
## [22] "current_project_status"
## [23] "project_name"
## [24] "project_start_date"
## [25] "project_shutdown_date"
## [26] "project_type_category"
## [27] "lfg_energy_project_type"
## [28] "rng_delivery_method"
## [29] "actual_mw_generation"
## [30] "rated_mw_capacity"
## [31] "lfg_flow_to_project_mmscfd"
## [32] "current_year_emission_reductions_mmtco2e_yr_direct"
## [33] "current_year_emission_reductions_mmtco2e_yr_avoided"
anaerobicdigesterfas_clean = clean_names(anaerobicdigesterfas_raw)
names(anaerobicdigesterfas_clean)## [1] "project_name"
## [2] "project_type"
## [3] "city"
## [4] "county"
## [5] "state"
## [6] "digester_type"
## [7] "status"
## [8] "year_operational"
## [9] "animal_farm_type_s"
## [10] "cattle"
## [11] "dairy"
## [12] "poultry"
## [13] "swine"
## [14] "co_digestion"
## [15] "biogas_generation_estimate_cu_ft_day"
## [16] "electricity_generated_k_wh_yr"
## [17] "biogas_end_use_s"
## [18] "system_designer_s_developer_s_and_affiliates"
## [19] "receiving_utility"
## [20] "total_emission_reductions_mtco2e_yr"
## [21] "awarded_usda_funding"
## [1] "facility_name" "category"
## [3] "type" "city"
## [5] "state" "start_date"
## [7] "gas_flow_to_project_scfm" "source"
## [9] "date_updated" "latitude"
## [11] "longitude" "x"
## [13] "y"
| landfill_name | project_name | state | waste_in_place_tons | lfg_energy_project_type | project_start_date |
|---|---|---|---|---|---|
| Anchorage Regional Landfill | Project #1 | AK | 10400368 | Reciprocating Engine | 2012-07-31 |
| Anchorage Regional Landfill | Project #1, Expansion #1 | AK | 10400368 | Reciprocating Engine | 2014-01-01 |
| Capitol Disposal Landfill | NA | AK | 950804 | Unknown | NA |
| Central Peninsula Landfill (CPL) | Project #1 | AK | 1721799 | Cogeneration | 2023-01-01 |
| Kodiak Island Borough Landfill | NA | AK | 228688 | Unknown | NA |
| project_name | state | project_type | animal_farm_type_s | year_operational | biogas_end_use_s |
|---|---|---|---|---|---|
| Cargill - Sandy River Farm Digester | AR | Farm Scale | Swine | 2008 | Flared Full-time |
| Butterfield RNG Digester | AZ | Farm Scale | Dairy | 2021 | Pipeline Gas |
| Caballero Dairy Farms Digester | AZ | Farm Scale | Dairy | 2022 | Pipeline Gas |
| Paloma Dairy Digester | AZ | Farm Scale | Dairy | NA | CNG |
| Stotz Southern Dairy Digester | AZ | Farm Scale | Dairy | 2011 | Electricity |